package br.trainee.web.dao.service;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;







import br.trainee.web.vo.ClinicaVO;
import br.trainee.web.vo.EmailClinicaVO;
import br.trainee.web.vo.EnderecoClinicaVO;
import br.trainee.web.vo.TelefoneClinicaVO;

public interface old_IClinicaDAO_old extends IDAO<ClinicaVO> {
	
	boolean incluirEmail(List<EmailClinicaVO> emails, Connection conexao) throws SQLException;
	boolean incluirTelefone(List<TelefoneClinicaVO> telefones, Connection conexao) throws SQLException;
	boolean incluirEndereco(List<EnderecoClinicaVO> enderecos, Connection conexao) throws SQLException;

	ClinicaVO detalharClinica(Long idClinica);
	ClinicaVO consultarFotoPorId(Long idClinica);
	@Override
	public ClinicaVO consultarPorId(Long id);
	List<ClinicaVO> consultarTodosClinica(String nome, String cnpj);
	
	boolean alterarEmail(EmailClinicaVO email);
	boolean alterarEndereco(EnderecoClinicaVO endereco);
	boolean alterarTelefone(TelefoneClinicaVO telefone);
	
	EmailClinicaVO consultarEmailPorId(Long idEmail);
	EnderecoClinicaVO consultarEnderecoPorId(Long idEndereco);
	TelefoneClinicaVO consultarTelefonePorId(Long idTelefone);
	
	boolean excluirEmail(Long idEmail);
	boolean excluirTelefone(Long idTelefone);
	boolean excluirEndereco(Long idEndereco);
	
	List<EnderecoClinicaVO> consultarEnderecosGeral(Long idClinica);
	List<EmailClinicaVO> consultarEmailsGeral(Long idClinica);
	List<TelefoneClinicaVO> consultarTelefoneGeral(Long idClinica);
	
	

}
